﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Jzy;

namespace FortuneHeaven.Entity.Accounts
{
    public partial class AccountsInfo : EntityBase
    {
        private const string TABLE_NAME = "AccountsInfo";
        private const string INSERT_SQL = "insert into AccountsInfo ( [UserID], [GameID], [ProtectID], [Accounts], [RegAccounts], [UnderWrite], [LogonPass], [InsurePass], [SpreaderID], [FaceID], [Experience], [UserRight], [MasterRight], [ServiceRight], [MasterOrder], [MemberOrder], [MemberOverDate], [Loveliness], [Gender], [Nullity], [StunDown], [MoorMachine], [MachineSerial], [WebLogonTimes], [GameLogonTimes], [RegisterIP], [LastLogonIP], [RegisterDate], [LastLogonDate], [CustomFaceVer], [Add_RealName], [Add_IDNumber], [Add_Area], [Add_BankName], [Add_BankID], [Add_MobilePhone], [Add_Reserve1], [Add_Reserve2], [UserType], [OnLinetime], [OnLineChageDate], [OnLineFlag], [NetBarID]) values ( @UserID, @GameID, @ProtectID, @Accounts, @RegAccounts, @UnderWrite, @LogonPass, @InsurePass, @SpreaderID, @FaceID, @Experience, @UserRight, @MasterRight, @ServiceRight, @MasterOrder, @MemberOrder, @MemberOverDate, @Loveliness, @Gender, @Nullity, @StunDown, @MoorMachine, @MachineSerial, @WebLogonTimes, @GameLogonTimes, @RegisterIP, @LastLogonIP, @RegisterDate, @LastLogonDate, @CustomFaceVer, @Add_RealName, @Add_IDNumber, @Add_Area, @Add_BankName, @Add_BankID, @Add_MobilePhone, @Add_Reserve1, @Add_Reserve2, @UserType, @OnLinetime, @OnLineChageDate, @OnLineFlag, @NetBarID)";
        private const string UPDATE_SQL = "update AccountsInfo set  [UserID] = @UserID, [GameID] = @GameID, [ProtectID] = @ProtectID, [Accounts] = @Accounts, [RegAccounts] = @RegAccounts, [UnderWrite] = @UnderWrite, [LogonPass] = @LogonPass, [InsurePass] = @InsurePass, [SpreaderID] = @SpreaderID, [FaceID] = @FaceID, [Experience] = @Experience, [UserRight] = @UserRight, [MasterRight] = @MasterRight, [ServiceRight] = @ServiceRight, [MasterOrder] = @MasterOrder, [MemberOrder] = @MemberOrder, [MemberOverDate] = @MemberOverDate, [Loveliness] = @Loveliness, [Gender] = @Gender, [Nullity] = @Nullity, [StunDown] = @StunDown, [MoorMachine] = @MoorMachine, [MachineSerial] = @MachineSerial, [WebLogonTimes] = @WebLogonTimes, [GameLogonTimes] = @GameLogonTimes, [RegisterIP] = @RegisterIP, [LastLogonIP] = @LastLogonIP, [RegisterDate] = @RegisterDate, [LastLogonDate] = @LastLogonDate, [CustomFaceVer] = @CustomFaceVer, [Add_RealName] = @Add_RealName, [Add_IDNumber] = @Add_IDNumber, [Add_Area] = @Add_Area, [Add_BankName] = @Add_BankName, [Add_BankID] = @Add_BankID, [Add_MobilePhone] = @Add_MobilePhone, [Add_Reserve1] = @Add_Reserve1, [Add_Reserve2] = @Add_Reserve2, [UserType] = @UserType, [OnLinetime] = @OnLinetime, [OnLineChageDate] = @OnLineChageDate, [OnLineFlag] = @OnLineFlag, [NetBarID] = @NetBarID where ID = @ID";
        /// <summary>
        /// 用户标识
        /// </summary>
        public Int32 UserID
        {
            get;
            set;
        }
        /// <summary>
        /// 游戏标识
        /// </summary>
        public Int32 GameID
        {
            get;
            set;
        }
        /// <summary>
        /// 密保标识
        /// </summary>
        public Int32 ProtectID
        {
            get;
            set;
        }
        /// <summary>
        /// 用户帐号
        /// </summary>
        public String Accounts
        {
            get;
            set;
        }
        /// <summary>
        /// 注册帐号
        /// </summary>
        public String RegAccounts
        {
            get;
            set;
        }
        /// <summary>
        /// 个性签名
        /// </summary>
        public String UnderWrite
        {
            get;
            set;
        }
        /// <summary>
        /// 登录密码
        /// </summary>
        public String LogonPass
        {
            get;
            set;
        }
        /// <summary>
        /// 安全密码
        /// </summary>
        public String InsurePass
        {
            get;
            set;
        }
        /// <summary>
        /// 推荐人标识
        /// </summary>
        public Int32 SpreaderID
        {
            get;
            set;
        }
        /// <summary>
        /// 头像标识
        /// </summary>
        public Int16 FaceID
        {
            get;
            set;
        }
        /// <summary>
        /// 经验数值
        /// </summary>
        public Int32 Experience
        {
            get;
            set;
        }
        /// <summary>
        /// 用户权限
        /// </summary>
        public Int32 UserRight
        {
            get;
            set;
        }
        /// <summary>
        /// 管理权限
        /// </summary>
        public Int32 MasterRight
        {
            get;
            set;
        }
        /// <summary>
        /// 服务权限
        /// </summary>
        public Int32 ServiceRight
        {
            get;
            set;
        }
        /// <summary>
        /// 管理等级
        /// </summary>
        public Byte MasterOrder
        {
            get;
            set;
        }
        /// <summary>
        /// 会员等级
        /// </summary>
        public Byte MemberOrder
        {
            get;
            set;
        }
        /// <summary>
        /// 过期日期
        /// </summary>
        public DateTime MemberOverDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Int32 Loveliness
        {
            get;
            set;
        }
        /// <summary>
        /// 用户性别
        /// </summary>
        public Byte Gender
        {
            get;
            set;
        }
        /// <summary>
        /// 禁止服务
        /// </summary>
        public Boolean Nullity
        {
            get;
            set;
        }
        /// <summary>
        /// 关闭标志
        /// </summary>
        public Boolean StunDown
        {
            get;
            set;
        }
        /// <summary>
        /// 固定机器
        /// </summary>
        public Byte MoorMachine
        {
            get;
            set;
        }
        /// <summary>
        /// 机器序列
        /// </summary>
        public String MachineSerial
        {
            get;
            set;
        }
        /// <summary>
        /// 登录次数
        /// </summary>
        public Int32 WebLogonTimes
        {
            get;
            set;
        }
        /// <summary>
        /// 登录次数
        /// </summary>
        public Int32 GameLogonTimes
        {
            get;
            set;
        }
        /// <summary>
        /// 注册地址
        /// </summary>
        public String RegisterIP
        {
            get;
            set;
        }
        /// <summary>
        /// 登录地址
        /// </summary>
        public String LastLogonIP
        {
            get;
            set;
        }
        /// <summary>
        /// 注册时间
        /// </summary>
        public DateTime RegisterDate
        {
            get;
            set;
        }
        /// <summary>
        /// 登录时间
        /// </summary>
        public DateTime LastLogonDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Byte? CustomFaceVer
        {
            get;
            set;
        }
        /// <summary>
        /// 真实姓名
        /// </summary>
        public String Add_RealName
        {
            get;
            set;
        }
        /// <summary>
        /// 身份证号
        /// </summary>
        public String Add_IDNumber
        {
            get;
            set;
        }
        /// <summary>
        /// 区域
        /// </summary>
        public String Add_Area
        {
            get;
            set;
        }
        /// <summary>
        /// 银行开户行名称
        /// </summary>
        public String Add_BankName
        {
            get;
            set;
        }
        /// <summary>
        /// 银行卡号
        /// </summary>
        public String Add_BankID
        {
            get;
            set;
        }
        /// <summary>
        /// 手机号码
        /// </summary>
        public String Add_MobilePhone
        {
            get;
            set;
        }
        /// <summary>
        /// 保留字段1
        /// </summary>
        public String Add_Reserve1
        {
            get;
            set;
        }
        /// <summary>
        /// 保留字段2
        /// </summary>
        public String Add_Reserve2
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Byte? UserType
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Int32? OnLinetime
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? OnLineChageDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Byte? OnLineFlag
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Int32? NetBarID
        {
            get;
            set;
        }
        public override void SetValue(string key, object value)
        {
            key = key.ToLower();
            switch (key)
            {
                case "userid":
                    this.UserID = (Int32)value;
                    break;
                case "gameid":
                    this.GameID = (Int32)value;
                    break;
                case "protectid":
                    this.ProtectID = (Int32)value;
                    break;
                case "accounts":
                    this.Accounts = (String)value;
                    break;
                case "regaccounts":
                    this.RegAccounts = (String)value;
                    break;
                case "underwrite":
                    this.UnderWrite = (String)value;
                    break;
                case "logonpass":
                    this.LogonPass = (String)value;
                    break;
                case "insurepass":
                    this.InsurePass = (String)value;
                    break;
                case "spreaderid":
                    this.SpreaderID = (Int32)value;
                    break;
                case "faceid":
                    this.FaceID = (Int16)value;
                    break;
                case "experience":
                    this.Experience = (Int32)value;
                    break;
                case "userright":
                    this.UserRight = (Int32)value;
                    break;
                case "masterright":
                    this.MasterRight = (Int32)value;
                    break;
                case "serviceright":
                    this.ServiceRight = (Int32)value;
                    break;
                case "masterorder":
                    this.MasterOrder = (Byte)value;
                    break;
                case "memberorder":
                    this.MemberOrder = (Byte)value;
                    break;
                case "memberoverdate":
                    this.MemberOverDate = (DateTime)value;
                    break;
                case "loveliness":
                    this.Loveliness = (Int32)value;
                    break;
                case "gender":
                    this.Gender = (Byte)value;
                    break;
                case "nullity":
                    this.Nullity = (Boolean)value;
                    break;
                case "stundown":
                    this.StunDown = (Boolean)value;
                    break;
                case "moormachine":
                    this.MoorMachine = (Byte)value;
                    break;
                case "machineserial":
                    this.MachineSerial = (String)value;
                    break;
                case "weblogontimes":
                    this.WebLogonTimes = (Int32)value;
                    break;
                case "gamelogontimes":
                    this.GameLogonTimes = (Int32)value;
                    break;
                case "registerip":
                    this.RegisterIP = (String)value;
                    break;
                case "lastlogonip":
                    this.LastLogonIP = (String)value;
                    break;
                case "registerdate":
                    this.RegisterDate = (DateTime)value;
                    break;
                case "lastlogondate":
                    this.LastLogonDate = (DateTime)value;
                    break;
                case "customfacever":
                    this.CustomFaceVer = (Byte?)value;
                    break;
                case "add_realname":
                    this.Add_RealName = (String)value;
                    break;
                case "add_idnumber":
                    this.Add_IDNumber = (String)value;
                    break;
                case "add_area":
                    this.Add_Area = (String)value;
                    break;
                case "add_bankname":
                    this.Add_BankName = (String)value;
                    break;
                case "add_bankid":
                    this.Add_BankID = (String)value;
                    break;
                case "add_mobilephone":
                    this.Add_MobilePhone = (String)value;
                    break;
                case "add_reserve1":
                    this.Add_Reserve1 = (String)value;
                    break;
                case "add_reserve2":
                    this.Add_Reserve2 = (String)value;
                    break;
                case "usertype":
                    this.UserType = (Byte?)value;
                    break;
                case "onlinetime":
                    this.OnLinetime = (Int32?)value;
                    break;
                case "onlinechagedate":
                    this.OnLineChageDate = (DateTime?)value;
                    break;
                case "onlineflag":
                    this.OnLineFlag = (Byte?)value;
                    break;
                case "netbarid":
                    this.NetBarID = (Int32?)value;
                    break;
            }
        }
    }


}
